Database Fields Available for Documents
The fields shown here are available for selection on the Document Maintenance dialog for insertion into a document.
VoterName |
Voter's name formatted as Last-Name, First-Name Middle-Name Style-Suffix. Note: For line printer
forms where the maximum length of the string is known, this format
is progressively shortened using middle initial, first initial,
and finally dropping name style if necessary.
|
VoterNameLMF |
Voter's name formatted as First-Name Middle-Name Last-Name Style-Suffix. Note: For line printer
forms where the maximum length of the string is known, this format
is progressively shortened using the middle initial, first initial,
and finally dropping name style if necessary.
|
Address1 |
Voter's
mailing address if available, otherwise the first line of the
residence address. |
Address2 |
If the mailing address is available, the next line is shown, otherwise the city, state, and zip code line of the residence address. |
Address3 |
Third line of the mailing address if available. |
Address4 |
Fourth line of the mailing address if available. |
Mail1 |
First line of the mailing address. Blank if no mailing address. |
Mail2 |
Second line of the mailing address. Blank if no mailing address. |
Mail3 |
Third line of the mailing address. Blank if no mailing address. |
MailCtySt |
City, state, and zip code of the mailing address. Blank if no mailing address. |
MailCityName |
Mailing address city. Blank if no mailing address. |
MailState |
Mailing address state. Blank if no mailing address. |
MailZip |
Mailing address zip code. Blank if no mailing address. |
MailCountry |
Mailing address country. Blank if no mailing address. |
Residence |
Formatted residence-address line. |
ResidenceProt |
For voters with a protected address, the text ** Protected ** prints in place of the residence address. The address appears as usual for voters whose address is not protected. |
ResCtySt |
Formatted residence city and state line. |
ResCtyStProt |
For voters with a protected address, the text ** Protected ** prints in place of the city and state of the residence address. The city and state appears as usual for voters whose address is not protected. |
ResCounty |
Voter's county of residence. |
FullResidence |
Full one-line residence address including city name, state, and zip code. |
USPSCity |
USPS city name for residence address. |
Party |
Party code. |
PartyName |
Party name (up to 40 characters). |
Sex |
Sex code. |
Race |
Race code. |
RaceShortDesc |
Race short description (W, B, etc). |
Regn Code |
Registration code. |
|
Registration |
BirthDate |
Voter's date of birth. |
BirthPlace |
Voter's state or country of birth. |
Assistance |
Prints a Y for voters with Assistance flag set to Y or an N for voters who do not have the Assistance flag set. |
AssistanceX |
The value specified in Voter Focus Admin > System Options > VIC Options > Assistance Required Text for Voter ID Cards. |
AssistanceN |
Prints an X if assistance not required. |
AssistanceY |
Prints an X if assistance is required. |
CongDist |
US Congressional district number. |
FLSenate |
Florida Senate seat. |
FLHouse |
Florida House seat. |
County |
County Commission seat. |
SchlBrd |
School Board seat. |
Dst-{district} |
Seat number for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
DSC-{district} |
District type for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
Short-DSC-{district} |
Short description for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
Inc-{district} |
Incumbent's name. Note: Your
database will have multiple fields of this type, one for each
district.
|
IncParty-{district} |
Incumbent's party. Note: Your
database will have multiple fields of this type, one for each
district.
|
IncCont-{district} |
Incumbent's contact information. Note: Your
database will have multiple fields of this type, one for each
district.
|
CityCode |
City in which the voter can vote. |
CityName |
City name for which the voter can vote. |
CityLongName |
The full name of the city (20 characters). |
CityWard |
City ward in which the voter can vote. |
TodaysDate |
Date at time of printing. |
Precinct |
Voter's precinct ID. |
PrecinctPart |
Voter's precinct split. |
Status |
Voter's registration status code. |
StatusDesc |
Text description of the voter's status code. |
ReasonCode |
Voter's status reason code. |
ReasonDesc |
Text description of the voter's status reason code. |
PrcLocn |
Place name of the voter's polling place. |
PrcRegionDesc |
Polling place region description. |
PrcAddress |
Street address of a voter's polling place. |
PrcCityStZp |
City, state and zip code for voter's polling place. |
Directions |
Directions to the voter's polling place. |
PersonIC |
Person in charge at the voter's polling place. |
CntctPsn |
Contact person at the voter's polling place. |
WardPlace |
City ward place name. |
WardLocn |
City ward place address. |
WardDirections |
City ward directions. |
CreationDate |
Creation date of the voter's record. |
LastActivity |
Last activity date of the voter. |
StatusChange |
Date the voter status was last changed. |
BarCode |
Prints a bar code on a page printer and MT691 printer. |
CardReason |
Reason for sending voter information card. |
DenialIncompReason |
Reason for denial of registration or reason why registration is considered incomplete. |
AbsenteeReason |
Reason for rejecting mail ballot request. |
VCrdMsg1 - 16 |
Voter Card message lines 1 through 16 (multiple fields). |
ElectionName |
Election name. |
ElectionDate |
Date of election. |
ElectionNumber |
Election number. |
ElectionType |
Election type (Primary or General). |
BallotStyle |
Voter's ballot style for this election. |
BallotNumber |
Ballot number. |
BallotBarNbr |
Ballot bar code number. |
AbsLabelDataLine |
Absentee data line. |
AbsBarCode |
Absentee bar code. |
PrecWorked |
Election worker precinct worked. |
PrecPlace |
Election worker precinct worked place name. |
PrecLocn |
Election workerprecinct worked address. |
PrecDirections |
Election worker precinct worked directions. |
PosnCode |
Election worker position code. |
PosnDescription |
Election worker position description. |
CheckAmtDigits |
Election worker payroll check amount in digits. |
CheckAmtWords |
Election worker payroll check amount in text. |
YTD Amount |
Election worker payroll year-to-date pay. |
PayDesc1 - 6 |
Election worker payroll description of pay item 1 through 6 (multiple fields). |
ReplacesCheck |
Election worker payroll check "replaces check 9999999." |
LastName |
Registration form - voter's last name. |
FirstName |
Registration form - voter's first name. |
MiddleName |
Registration form - voter's middle name. |
NameStyle |
Registration form - voter's name style. |
ResAddrNoAppt |
Registration form - Residence address without apartment number. |
Apartment |
Registration form - voter's apartment number. |
ResZip |
Registration form - voter's zip code. |
SSN4Digits |
Registration form - voter's social security number (last 4 digits only). |
SSN9Digits |
Voter's social security number (all 9 digits). |
NoDsn-NoSSN |
Voter claims no driver license or social security number. |
HomePhone |
Voter's home phone number. |
DriversLicense |
Voter's driver license number. |
<party name>X |
Registration form - prints "X" in box for voter's party (Dem, Rep, NPA, or Other). |
OtherParty |
Registration form - prints name of the other party. |
Sex<sex name>X |
Registration form - prints "X" in box for voter's sex. |
Race<race name>X |
Registration form - prints "X" in box for voter's race. |
FormerName |
Registration form - voter's former name. |
FormerNameOnly |
Registration form - voter's former name (blank if there are entries in the former address fields). |
FormerAddr1 - 3 |
Registration form - voter's former address lines 1 through 3 (multiple fields). |
FormerCity |
Registration form - voter's former city. |
FormerCounty |
Registration form - voter's former county of residence. |
FormerState |
Registration form - voter's former state. |
FormerZip |
Registration form - voter's former zip code. |
CountyName |
Your county name. |
PWInterested |
Voter is interested in election work. |
MilitaryX |
Prints "X" for military voters. |
MilitaryDepX |
Prints "X" for military dependent voters. |
OverseasX |
Prints "X" for overseas voter civilian voters. |
AbAddress1-5 |
Vote-By-Mail address lines 1 through 5 (multiple fields). |
AbsFontBarCode |
Vote-By-Mail Windows-font bar code. |
PetAddrNoApt |
Petition address change - address line without apartment. |
PetAddrApt |
Petition address change - address line with apartment. |
PetAddrCityName |
Petition address change - city name. |
PetAddrZip |
Petition address change - zip code. |
PetitionName |
Petition address change - petition name. |
PrvnlTracking |
Provisional ballot tracking number. |
ProvisionalReason |
Reason for provisional ballot. |
PrvnlTabulated |
Provisional ballot accepted. |
PrvnlFindings |
Provisional ballot findings. |
PrvnlRejReason |
Reason provisional ballot was rejected. |
USPSConfirmCode |
Bar code for USPS tracking (counties with the USPS Confirm One Interface). |
PublicEmailAddress |
Voter's email address from the Maint tab of their record. |
SampleBallotsByEmail |
Y if the voter wants to receive their sample ballots via email; N if they do not. |